Microsoft Excel is a widespread tool among controllers and planners due to its flexibility and ease of use. Working with Excel Export and Import lets you create budgets in LS Central, export and maintain them in Excel, and to re-import into LS Nav. You can import the Excel spreadsheet into the original budget and either overwrite or append to the existing information. Alternatively, you can import the Excel spreadsheet to a different budget, allowing various workflows and processes.
When the budget is exported from a Retail Sales Budget, the data is stored in an Excel file (with extension .xlsx) in a temporary location. The exported Sales Budget data is not deleted from the original Retail Sales Budget. This functionality lets you extract a copy of the Sales Budget data to be used for further analysis and consolidation in Microsoft Excel. Sales Budget data can also be moved to another company's Retail Sales Budget with Microsoft Excel files.
To export sales budget data from Retail Sales Budget into a Microsoft Excel file
- Navigate LS Retail – Replenishment, Open-to-Buy - Retail Sales Budget List.
- In the Retail Sales Budget List, select a budget to export, and click Sales Budget on the Home menu.
- Click the Export Budget to Excel action.
- Fill in all fields as needed:
- State a Start Date, No. of Periods, and Period Length.
- Select the Budget Name and Division Code filters on the Retail Sales Budget Entry FastTab.
To import sales budget data from a Microsoft Excel file into Retail Sales Budget
- Navigate LS Retail – Replenishment, Open-to-Buy - Retail Sales Budget List.
- In the Retail Sales Budget List, select a budget, and click Sales Budget on the Home menu.
- Click the Import Budget from Excel action.
- Fill in all fields as needed:
- Enter a Workbook File Name and Worksheet Name where you want to retrieve the data from.
- State the Budget Name where you want the Sales Budget data imported to, and specify the Store No., Option, and Description for that particular budget.